CREATE PROCEDURE dbo.[GetAfiliadosJefes_Activos]
AS
BEGIN
select * from Persona
where Persona.Activo = 1 and Persona.Afiliado = 1 and Persona.ID in (select g.Jefe
from GrupoFamiliar g where g.Activo = 1);
END
GO
